create table if not exists d_rnt_wimp_rm_ap_info_d_#{PARTITION_DATE}
 (
device_id    varchar(32) ,
sys_name    varchar(256) ,
alias    varchar(128) ,
ip_addr    varchar(20) ,
mac_addr    varchar(20) ,
netmask    varchar(20) ,
city    varchar(20) ,
district    varchar(20) ,
ac_name    varchar(256) ,
ac_ip    varchar(20) ,
hotspot_name    varchar(128) ,
nas_id    varchar(20) ,
coverage_type    varchar(20) ,
switch_name    varchar(256) ,
switch_ip    varchar(20) ,
serial_number    varchar(128) ,
device_model    varchar(128) ,
software_name    varchar(128) ,
software_version    varchar(128) ,
vendor    varchar(20) ,
current_channel    bigint ,
current_power    bigint ,
support_mode    varchar(20) ,
current_mode    varchar(20) ,
sys_location    varchar(255) ,
coverage_scope    varchar(256) ,
asset_id    varchar(40) ,
project_status    varchar(40) ,
create_time    datetime ,
site_name    varchar(255) ,
room_name    varchar(255) ,
network_rp_name    varchar(255) ,
if2g3g    bigint ,
online_status    bigint ,
remark    varchar(256) ,
radio_mac_addr    varchar(256) ,
ac_id    varchar(40) ,
hotspot_id    varchar(40)
)   compress(5, 5)  nolock ;